BEGIN TRANSACTION AddCity1
	BEGIN TRY
		INSERT INTO [City] (CityId, CityName, RegionCode)
		VALUES (1, 'Swansea', 10001);
		
		COMMIT TRANSACTION AddCity1;
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddCity1;
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;

BEGIN TRANSACTION AddCity2
	BEGIN TRY
		INSERT INTO [City] (CityId, CityName, RegionCode)
		VALUES (2, 'Cardiff', 10002);
		
		COMMIT TRANSACTION AddCity2;
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddCity2;
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;

BEGIN TRANSACTION AddCity3
	BEGIN TRY
		INSERT INTO [City] (CityId, CityName, RegionCode)
		VALUES (3, 'London', 10003);
		
		COMMIT TRANSACTION AddCity3;
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddCity3;
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;

BEGIN TRANSACTION AddCity4
	BEGIN TRY
		INSERT INTO [City] (CityId, CityName, RegionCode)
		VALUES (4, 'Birmingham', 0004);
		
		COMMIT TRANSACTION AddCity4;
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddCity4;
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;




